Hệ thống quản lý trường học bằng PHP / MySQLi
1 <?php
2 error_reporting(0);//turning off error reporting
3 include("connect.php");
4 ?>
5 <?php
6 $id=$_GET['id'];
7 ?>
8
9 <?php
10 SESSION_START();
11 ?>
12
13 <?php
14 if (isset($_POST['register'])){
15
16 $del=$_POST['course'];
17 $sql = "DELETE FROM course WHERE course_id='$del'";
18 mysqli_query($db,$sql);
19 if ($sql){
20 echo $del;
21 }else
22 {
23 echo '<script>
24 alert("Record not deleted. Contact admin");
25 window.location = "course.php?id=<?php echo $id;?>";
26 </script>';
27 }
28 }
29
30 ?>
31
32
33
34 <!DOCTYPE html>
35 <html>
36
37 <head>
38 <meta charset="utf-8">
39 <meta name="viewport" content="width=device-width, initial-scale=1.0">
40 <title>school management system</title>
41 <link rel="shortcut icon" href="assets/img/title.gif" type="image/x-icon">
42 <link rel="stylesheet" href="assets/css/bootstrap.min.css">
43 <link href="assets/css/loader.css" rel="stylesheet" />
44 <script src="assets/js/canvasjs.min.js"></script>
45 <!--*****jquery -3.2.1.js file supports the use of dropdown***-->
46 <script src="assets/js/jquery-3.2.1.js"></script>
47 </head>
48
49 <body >
50 <!--end of heading section-->
51 <ul class="nav navbar-right top-nav">
52 <div class="dropdown">
53 <button class="btn btn-primary dropdown-toggle" type="button" data-toggle="dropdown" >
54 <?php
55 //Check to see if the user is logged in.if not redirect user to the loging page.
56
57 if(isset($_SESSION['fname']))
58 {
59 echo "Current user: ".$_SESSION['fname']. " ".$_SESSION['lname']. " ";
60 }else{
61 echo "<script type='text/javascript'>
62 alert( 'You must Log in to use the system');
63 </script>";
64 echo "<script>
65 window.location = 'index.php'
66 </script>";
67 }
68 ?>
69 <span class="caret"></span></button>
70 <ul class="dropdown-menu">
71 <li><a href="manage_account.php"><i class="fa fa-users fa-lg"></i> View User</a></li>
72 <li><a href="register_form.php"><i class="fa fa-users fa-lg"></i> Add New User</a></li>
73 <li class="divider"></li>
74 <li><a href="session_logout.php"><i class="fa fa-fw fa-power-off"></i> Log Out</a></li>
75 </ul>
76 </div>
77 </ul>
78 <!--************************************************-->
79 <div style="
80 font-family:Nyala, Arial;
81 text-align: left;
82 background-color: #526F35;
83 padding: 20px;
84 color:white;
85 width: 100%;
86 height: 150px;">
87 <!--This codes to load the image loader-->
88 <div id="loading">
89 <img id="loading-image" src="assets/img/loader.gif" alt="Loading..." />
90 </div>
91 <!--this is the heading section-->
92 <h2>
93 <?php
94 $sql="SELECT * FROM companyinfo";
95 $result=mysqli_query($db,$sql) or die("error getting data");
96 $num_rows=mysqli_num_rows($result);
97 while($row=mysqli_fetch_array($result))
98 {
99 echo '<image style="height:82px; width:82px;" src="data:image;base64,'. $row['clogo'].' "> ';
100 $cname = $row['cname'];
101 $cemail = $row['cemail'];
102 $ccontact = $row['ccontact'];
103 $clocation = $row['clocation'];
104 }?>
105 <?php
106 echo $cname;
107 ?>
108
109 <div style="float:right; font-size:20px;text-align:right;">
110
111 <img src="assets/img/mail2.png">Email: <?php echo $cemail; ?><br>
112 <img src="assets/img/call1.png">Contact:<?php echo $ccontact; ?><br>
113 <img src="assets/img/location.png">Location: <?php echo $clocation; ?>
114
115 </div>
116 </h2>
117 </div>
118 <!--end of heading section-->
119 <div>
120 <ul class="nav nav-tabs">
121 <li ><a href="homepage.php" >Administration <img src="assets/img/details.png"></a></li>
122 <li ><a href="students.php" >Students <img src="assets/img/student48.png"></a></li>
123 <li><a href="staff.php">Staff Member <img src="assets/img/staff48.png"></a></li>
124 <li class="active"><a href="course.php" >Courses <img src="assets/img/course.png"></a></li>
125 <li><a href="departments.php" >Departments <img src="assets/img/department.png"></a></li>
126 <li ><a href="markstep1.php" >Exams <img src="assets/img/update.png"></a></li>
127 <li><a href="hostel.php" >Hostel <img src="assets/img/details.png"></a></li>
128 <li><a href="sms.php">SMS <img src="assets/img/details.png"></a></li>
129 <!--<li><a href="tab-8" role="tab" data-toggle="tab">Hostel <img src="assets/img/details.png"></a></li>
130 <li><a href="tab-7" role="tab" data-toggle="tab">Parents <img src="assets/img/details.png"></a></li>-->
131
132 </ul>
133 <div class="tab-content">
134 <div class="tab-pane active" role="tabpanel" id="tab-1">
135
136 <p>
137 <div class="table-responsive" >
138 <!--****************************************************************************-->
139
140 <div class="container" style="width:100%">
141
142 <ul class="nav nav-tabs">
143 <li ><a href="course.php">New Course<img src="assets/img/new.png"> </a></li>
144
145 <li><a href="editcourse.php">Edit course <img src="assets/img/update2.png"> </a></li>
146 <li><a href="csvtesting.php">Import/Export CSV<img src="assets/img/export.png"></a></li>
147 <li class="active"><a href="deletecourse.PHP">Delete <img src="assets/img/delete2.png"></a></li>
148 <li><a href="#">Manage Course </a></li>
149
150 </ul>
151 <br>
152
153 </div>
154
155 <!--*************************************************************************************************************************-->
156
157 <h4><center><h4><strong>Select Course to delete</strong></h4></center></h4>
158
159 <div class="row">
160 <div class="col-sm-3">
161 </div>
162 <div class="col-sm-6" >
163
164
165 <form method="POST" action="deletecourse.php">
166
167 <table cellpadding="0" cellspacing="0" border="0" class="table" id="example">
168
169 <tr>
170 <td>
171 <label>Class ID</label>
172 </td>
173 <td>
174 <input type="text" name="course" id="course" class="form-control" value="<?php echo $id ; ?>">
175 </td>
176 <tr>
177 <td colspan="2"><input type="submit" name="register" value="Delete" class="btn btn-primary" ></td>
178 </tr>
179 </tr>
180 </table>
181 </form>
182
183
184 <!--****************************************************************************-->
185
186
187 </div>
188 </p>
189
190 </div>
191
192 </div>
193 </div>
194
195 <div class="col-md-12" style="background-color:#526F35;bottom:0px; position:fixed;">
196 <p class="text-center text-danger" style="color:white;" >@J. Muthama Tel: +254729734768</p>
197 </div>
198 <script src="assets/js/jquery.min.js"></script>
199 <script src="assets/bootstrap/js/bootstrap.min.js"></script>
200 <script src="assets/js/affix.js"></script>
201 <script src="assets/js/alert.js"></script>
202 <script src="assets/js/alert1.js"></script>
203 <script src="assets/js/bootstrap.js"></script>
204 <script src="assets/js/bootstrap.min.js"></script>
205 <script src="assets/js/bootstrap-datepicker.js"></script>
206 <script src="assets/js/bootstrap-wysihtml5.js"></script>
207 <script src="assets/js/button.js"></script>
208 <script src="assets/js/carousel.js"></script>
209 <script src="assets/js/chosen.jquery.min.js"></script>
210 <script src="assets/js/ckeditor.js"></script>
211 <script src="assets/js/collapse.js"></script>
212 <script src="assets/js/color.js"></script>
213 <script src="assets/js/dropdown.js"></script>
214 <script src="assets/js/DT_bootstrap.js"></script>
215 <script src="assets/js/dynamic.js"></script>
216 <script src="assets/js/ie-emulation-modes-warning.js"></script>
217 <script src="assets/js/jquery.dataTables.js"></script>
218 <script src="assets/js/jquery.dataTables.min.js"></script>
219 <script src="assets/js/jquery.dialog.js"></script>
220 <script src="assets/js/jquery.hoverdir.js"></script>
221 <script src="assets/js/jquery.jgrowl.js"></script>
222 <script src="assets/js/jquery.knob.js"></script>
223 <script src="assets/js/jquery.uniform.min.js"></script>
224 <script src="assets/js/jquery-1.8.3.min.js"></script>
225 <script src="assets/js/jquery-1.9.1.js"></script>
226 <script src="assets/js/jquery-1.9.1.min.js"></script>
227 <script src="assets/js/jquery-1.10.2.js"></script>
228 <script src="assets/js/jquery-1.11.0.js"></script>
229 <script src="assets/js/jquery-ui-1.9.2.custom.min.js"></script>
230 <script src="assets/js/jquery-ui-1.10.3.js"></script>
231 <script src="assets/js/modal.js"></script>
232 <script src="assets/js/modernizr-2.6.2-respond-1.1.0.min.js"></script>
233 <script src="assets/js/myjquery.js"></script>
234 <script src="assets/js/myjquery1.js"></script>
235 <script src="assets/js/npm.js"></script>
236 <script src="assets/js/popover.js"></script>
237 <script src="assets/js/profile.js"></script>
238 <script src="assets/js/raphael-min.js"></script>
239 <script src="assets/js/sb-admin-2.js"></script>
240 <script src="assets/js/scripts.js"></script>
241 <script src="assets/js/scrollspy.js"></script>
242 <script src="assets/js/tab.js"></script>
243 <script src="assets/js/tooltip.js"></script>
244 <script src="assets/js/transition.js"></script>
245 <script src="assets/js/wysihtml5-0.3.0.js"></script>
246 <script language="javascript" type="text/javascript">
247 $(window).load(function()
248 {
249 $('#loading').hide();
250 });
251 </script>
252 </body>
253
254 </html>